package com.ssm.util.mybatis;

import java.util.ArrayList;
import java.util.LinkedHashSet;
import java.util.List;
import java.util.Set;

import org.apache.ibatis.type.TypeHandler;

public class CustomExample {
	protected boolean distinct;

	protected String orderByClause;
	
	protected String groupByClause;

	protected Set<String> selectColumns;

	protected List<Criteria> oredCriteria;

	public CustomExample() {
		oredCriteria = new ArrayList<Criteria>();
	}


	public String getGroupByClause() {
		return groupByClause;
	}


	public void setGroupByClause(String groupByClause) {
		this.groupByClause = groupByClause;
	}


	public boolean isDistinct() {
		return distinct;
	}

	public void setDistinct(boolean distinct) {
		this.distinct = distinct;
	}


	public String getOrderByClause() {
		return orderByClause;
	}

	public void setOrderByClause(String orderByClause) {
		this.orderByClause = orderByClause;
	}

	public Set<String> getSelectColumns() {
		return selectColumns;
	}

	/**
	 * 指定要查询的表字段
	 *
	 * @param properties
	 * @return
	 */
	public CustomExample selectProperties(String... properties) {
		if (properties != null && properties.length > 0) {
			if (this.selectColumns == null) {
				this.selectColumns = new LinkedHashSet<String>();
			}
		}
		return this;
	}


	public List<Criteria> getOredCriteria() {
		return oredCriteria;
	}

	public void or(Criteria criteria) {
		oredCriteria.add(criteria);
	}

	public Criteria or() {
		Criteria criteria = createCriteriaInternal();
		oredCriteria.add(criteria);
		return criteria;
	}

	public Criteria createCriteria() {
		Criteria criteria = createCriteriaInternal();
		if (oredCriteria.size() == 0) {
			oredCriteria.add(criteria);
		}
		return criteria;
	}

	protected Criteria createCriteriaInternal() {
		Criteria criteria = new Criteria();
		return criteria;
	}

	public void clear() {
		oredCriteria.clear();
		orderByClause = null;
		groupByClause = null;
	}

	protected abstract static class GeneratedCriteria {
		protected List<Criterion> criteria;

		protected GeneratedCriteria() {
			super();
			criteria = new ArrayList<Criterion>();
		}


		public boolean isValid() {
			return criteria.size() > 0;
		}

		public List<Criterion> getAllCriteria() {
			return criteria;
		}

		public List<Criterion> getCriteria() {
			return criteria;
		}

		protected void addCriterion(String condition) {
			if (condition == null) {
				throw new RuntimeException("Value for condition cannot be null");
			}
			if (condition.startsWith("null")) {
				return;
			}
			criteria.add(new Criterion(condition));
		}

		protected void addCriterion(String condition, Object value, String property) {
			if (value == null) {
				throw new RuntimeException("Value for " + property + " cannot be null");
			}
			if (property == null) {
				return;
			}
			criteria.add(new Criterion(condition, value));
		}

		protected void addCriterion(String condition, Object value1, Object value2, String property) {
			if (value1 == null || value2 == null) {
				throw new RuntimeException("Between values for " + property + " cannot be null");
			}
			if (property == null) {
				return;
			}
			criteria.add(new Criterion(condition, value1, value2));
		}

		public Criteria andIsNull(String property) {
			addCriterion(property + " is null");
			return (Criteria) this;
		}

		public Criteria andIsNotNull(String property) {
			addCriterion(property + " is not null");
			return (Criteria) this;
		}

		public Criteria andEqualTo(String property, Object value) {
			addCriterion(property + " =", value,property);
			return (Criteria) this;
		}

		public Criteria andNotEqualTo(String property, Object value) {
			addCriterion(property + " <>", value, property);
			return (Criteria) this;
		}

		public Criteria andGreaterThan(String property, Object value) {
			addCriterion(property + " >", value, property);
			return (Criteria) this;
		}

		public Criteria andGreaterThanOrEqualTo(String property, Object value) {
			addCriterion(property + " >=", value, property);
			return (Criteria) this;
		}

		public Criteria andLessThan(String property, Object value) {
			addCriterion(property + " <", value, property);
			return (Criteria) this;
		}

		public Criteria andLessThanOrEqualTo(String property, Object value) {
			addCriterion(property + " <=", value, property);
			return (Criteria) this;
		}

		public Criteria andIn(String property, List<?> values) {
			addCriterion(property + " in", values, property);
			return (Criteria) this;
		}

		public Criteria andNotIn(String property, List<?> values) {
			addCriterion(property + " not in", values,property);
			return (Criteria) this;
		}

		public Criteria andBetween(String property, Object value1, Object value2) {
			addCriterion(property + " between", value1, value2, property);
			return (Criteria) this;
		}

		public Criteria andNotBetween(String property, Object value1, Object value2) {
			addCriterion(property + " not between", value1, value2,property);
			return (Criteria) this;
		}

		public Criteria andLike(String property, String value) {
			addCriterion(property + "  like", value, property);
			return (Criteria) this;
		}

		public Criteria andNotLike(String property, String value) {
			addCriterion(property + "  not like", value, property);
			return (Criteria) this;
		}

		/**
		 * 手写条件
		 *
		 * @param condition 例如 "length(countryname)<5"
		 * @return
		 */
		public Criteria andCondition(String condition) {
			addCriterion(condition);
			return (Criteria) this;
		}

		/**
		 * 手写左边条件，右边用value值
		 *
		 * @param condition 例如 "length(countryname)="
		 * @param value     例如 5
		 * @return
		 */
		public Criteria andCondition(String condition, Object value) {
			criteria.add(new Criterion(condition, value));
			return (Criteria) this;
		}

		/**
		 * 手写左边条件，右边用value值
		 *
		 * @param condition   例如 "length(countryname)="
		 * @param value       例如 5
		 * @param typeHandler 类型处理
		 * @return
		 */
		public Criteria andCondition(String condition, Object value, String typeHandler) {
			criteria.add(new Criterion(condition, value, typeHandler));
			return (Criteria) this;
		}

		/**
		 * 手写左边条件，右边用value值
		 *
		 * @param condition   例如 "length(countryname)="
		 * @param value       例如 5
		 * @param typeHandler 类型处理
		 * @return
		 */
		public Criteria andCondition(String condition, Object value, @SuppressWarnings("rawtypes") Class<? extends TypeHandler> typeHandler) {
			criteria.add(new Criterion(condition, value, typeHandler.getCanonicalName()));
			return (Criteria) this;
		}
	}

	public static class Criteria extends GeneratedCriteria {
		protected Criteria() {
		}

	}

	public static class Criterion {
		private String condition;

		private Object value;

		private Object secondValue;

		private boolean noValue;

		private boolean singleValue;

		private boolean betweenValue;

		private boolean listValue;

		private String typeHandler;

		protected Criterion(String condition) {
			super();
			this.condition = condition;
			this.typeHandler = null;
			this.noValue = true;
		}

		protected Criterion(String condition, Object value, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.typeHandler = typeHandler;
			if (value instanceof List<?>) {
				this.listValue = true;
			} else {
				this.singleValue = true;
			}
		}

		protected Criterion(String condition, Object value) {
			this(condition, value, null);
		}

		protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.secondValue = secondValue;
			this.typeHandler = typeHandler;
			this.betweenValue = true;
		}

		protected Criterion(String condition, Object value, Object secondValue) {
			this(condition, value, secondValue, null);
		}

		public String getCondition() {
			return condition;
		}

		public Object getValue() {
			return value;
		}

		public Object getSecondValue() {
			return secondValue;
		}

		public boolean isNoValue() {
			return noValue;
		}

		public boolean isSingleValue() {
			return singleValue;
		}

		public boolean isBetweenValue() {
			return betweenValue;
		}

		public boolean isListValue() {
			return listValue;
		}

		public String getTypeHandler() {
			return typeHandler;
		}
	}
}
